/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 13:21:51
*/


-- ----------------------------
-- Table structure for tb0007
-- ----------------------------
DROP TABLE [dbo].[tb0007]
GO
CREATE TABLE [dbo].[tb0007] (
[InventoryID] varchar(20) NULL ,
[DivisionID] varchar(20) NULL ,
[WareHouseID] varchar(20) NULL ,
[ReVoucherID] varchar(20) NULL ,
[ReTransactionID] varchar(20) NULL ,
[ReVoucherNo] varchar(20) NULL ,
[ReVoucherDate] datetime NULL ,
[ReTranMonth] int NULL ,
[ReTranYear] int NULL ,
[ReSourceNo] varchar(30) NULL ,
[LimitDate] datetime NULL ,
[ReQuantity] decimal(28,8) NULL ,
[DeQuantity] decimal(28,8) NULL ,
[EndQuantity] decimal(28,8) NULL ,
[UnitPrice] decimal(28,8) NULL ,
[DeVoucherID] varchar(20) NULL ,
[DeTransactionID] varchar(20) NULL ,
[DeVoucherNo] varchar(20) NULL ,
[DeVoucherDate] varchar(20) NULL ,
[DeLocationNo] varchar(20) NULL ,
[DeTranMonth] int NULL ,
[DeTranYear] int NULL ,
[Status] tinyint NOT NULL DEFAULT ((0)) ,
[IsLocked] tinyint NOT NULL DEFAULT ((0)) 
)


GO


